class CreateJobs < ActiveRecord::Migration
  def self.up
    create_table :jobs do |t|
			t.column :name,       :string
      t.column :body,       :text
      t.column :department, :string
      t.column :created_at, :datetime
      t.column :updated_at, :datetime
    end

		Job.create(
    :department => "Operations",
    :name       => "Senior Windows Hosting Administrator - .NET",
    :body       => "<p><b>Responsibilities</b></p>
		<blockquote>
		<ul>
		<li>Architect and implement the Windows server based Telephony and Speech Applications Hosting platform.</li>
		<li>Deploy the appropriate Microsoft technologies for the hosting platform for the management and monitoring of a wide variety of .NET Windows Servers and Applications. The Windows Servers include Microsoft Speech Server, Microsoft SQL Servers, Live Communication Server, Sharepoint Server, CCF, Active Directory, Domain Controllers, etc.</li>
		<li>Provide the necessary technologies, tools, scripts and procedures for the installation, deployment, configuration, management and monitoring of the Windows servers and applications.</li>
		<li>Lead other administrators in management of MS deployments and instruction on MS best practices.</li>
		<li>Automation of installation of MS operating systems and third-party software.</li>
		<li>Advise on best practices for MS configuration management, packaging and deployment of internally developed software.</li>
		<li>Securing MS servers, e.g. installation of host intrusion detection systems like Tripwire and configuration URL filtering systems, and investigating security issues.</li>
		<li>Monitoring of MS systems and MS-based platforms, such as MSS, using MS, third-party, or in-house developed tools.</li>
		<li>Create and maintain documentation, including Network Operations Center procedures for technical support, debugging, notification, and escalation.</li>
		<li>Identify tasks which require automation and automate them.</li>
		<li>Write scripts and programs to integrate the Windows environment with the rest of the Vail platform facilities.</li>
		<li>Architect and implement a reports portal for delivery of reports to our customers.</li>
		<li>Provide input on future technological directions. </li>
		</ul>
		</blockquote>

		<p><b>Requirements</b></p>
		<blockquote>
		<ul>
		<li>BA/BS in Computer Science, Engineering or equivalent.</li>
		<li>MCSE</li>
		<li>5-8 years of .NET Windows Server management and administration experience, preferably in a hosting environment.</li>
		<li>Deep knowledge of a variety of Microsoft technologies.</li>
		<li>A solid understanding of a MS operating systems; understanding of paging and swapping, inter-process communication, devices and what device drivers do, filesystem concepts, can use performance analysis to tune systems.</li>
		<li>Excellent scripting knowledge in the Microsoft Windows Server environment such as WMI and VB scripting.</li>
		<li>Experience with Microsoft Speech Server and Microsoft SQL Server is a definite plus.</li>
		<li>A solid understanding of networking/distributed computing environment concepts; understands principles of routing, client/server programming, the design of consistent network-wide filesystem layouts. Ability to troubleshoot, isolate, and resolve network and distributed application problems.</li>
		<li>Experience with host security and host intrusion detection systems.</li>
		<li>Experience with network security (for example, building firewalls, deploying authentication systems, or applying cryptography to network applications) a plus.</li>
		<li>Strong inter-personal and communication skills; capable of writing proposals or papers, making presentations to customer or client audiences or professional peers.</li>
		<li>Familiarity with most aspects of UNIX systems administration preferred; for example, configuration of mail systems, system installation and configuration, printing systems, fundamentals of security, installing third-party software.</li>
		<li>Experience taking advantage of open-source projects and software when architecting solutions.</li>
		<li>Ability to solve problems quickly and completely; ability to resolve arbitrary network and system problems preferred.</li>
		</ul>
		</blockquote>"
    )

		Job.create(
		:department => "Client Services",
    :name       => "Client Services Associate",
    :body       => "<p>Vail Systems has an opening in our client services division. We are seeking a motivated and team oriented person to handle day to day assignments with Vail's growing number of telephony hosting clients.</p>

		<p><b>Responsibilities </b></p>
		<p>Establish relationships with assigned clients and proactively analyze, track and report on their application/s performance, growth, and needs. Serve as point of contact for principal clients and creatively identify problems and work with the team to help provide solutions. Maintain contact information for clients for dissemination of critical information. Work with programmers/engineers to help maintain and develop applications </p>

		<p><b>Qualifications</b></p>
		<blockquote>
		<ul>
		<li>Strong desire to work and learn in a technically advanced field</li>
		<li>Strong communication skills, both written and verbal</li>
		<li>Analytical and technical aptitude</li>
		<li>Ability to establish relationships of mutual trust and respect with clients</li>
		<li>Ability to work well in a team environment, as well as on your own</li>
		<li>Knowledge of MS Office (Excel, Word, Access)</li>
		<li>Self motivated and self-starter</li>
		</ul>
		</blockquote>"
  )

	Job.create(
	:department => "DB Web",
  :name       => "Software Engineer",
  :body       => "<p><b>Responsibilities</b></p>

	<p>Develop and support Voice/Web applications and infrastructure. The job requires a bachelor's degree in a related area and 5 years of experience in the field or in a related area.  The candidate will perform a variety of tasks to shepherd applications from concept to deployment.  Creativity and latitude is required. </p>

	<p><b>In particular, the engineer should be familiar with the following 
	</b></p>

	<blockquote>
	<ul>
	<li> UNIX operating systems (especially BSD variants and Solaris)</li>
	<li> XML technologies (VXML/CCXML especially helpful)</li>
	<li> Shell scripting</li>
	<li> A web framework such as Struts, Rails or Django.</li>
	<li> Perl</li>
	<li> Apache and CGI.</li>
	<li> Troubleshooting skills. </li>
	<li> Configuration management (CVS, pkgsrc, cfengine)</li>
	</ul>
	</blockquote>"
	)
	
	Job.create(
	:department => "Implementation Support",
  :name       => "Implementation Support Specialist",
  :body       => "<p>Vail Systems is looking for an Implementation Support Specialist with some technical experience and a desire to increase her or his interface with customer teams and impact on business results. The role involves interfacing with clients, Vail?s engineering groups and external partners to positively impact the delivery and support Vail solutions to clients.</p>

	<p><b>Key Responsibilities</b></p>
	<p>Under the Implementation Manager, execute assigned project tasks, including requirements definition, deliverable QA/AC, testing and task coordination. Create project schedules against goals and ensure it is aligned with prospect's or customer's expectations; integrate schedules between internal and external project teams. Apply technical troubleshooting and analytical skills to work through and/or escalate customer issues as necessary. Proactively manage client issues as necessary, working with customer support, engineering and account owner as required. Ensure technical documents, reports and test results are technically sound, clearly defined and actionable. Effectively team with engineering and support functions as required to align and co-ordinate implementation efforts. Facilitate sign-off of key deliverables. Monitor and report status of key milestones and deliverables under individual's control as assigned.</p>
	<p><b>Qualifications</b></p>
	<blockquotes><ul>
	  <li>An understanding of project management methodologies, tools and best practices.</li>
	  <li>Highly developed analytical and problem solving skills.</li>
	  <li>Basic knowledge of software development environments and integration would be helpful.</li>
	  <li>Detail-oriented mindset.</li>
	  <li>Excellent written and oral communication skills.</li>
	  <li>Ability to be highly credible and persuasive in all interactions with clients.</li>
	  <li>A minimum of three (3) years of relevant experience is desired. At least one (1) year of implementation or engineering experience in similar industry - including co-op or intern - is desired but not required. Also, experience with MS Access, MS Excel, MS Word and MS Visio. </li>
	</ul></blockquotes>"
	)
	
	Job.create(
 	:department => "Operations",
  :name       => "Technical NOC Manager",
  :body       => "<p><b>Responsibilities</p></b><p>The NOC Manager is required to have hands on supervision of NOC staff in regards to staffing, 24x7 coverage, tracking of vacation/sick time, writing and delivering annual performance review for NOC technicians.  In addition the NOC Manager will be required to have a flexible schedule and on-call availability.</p>
	<p><b>Requirements:</b></p>
	<blockquote>
	<ul><li>Bachelor degree in Computer Science, Computer Information Systems of equivalent is strongly preferred.</li>
	<li>Network Operations Center experience preferred.</li>
	<li>User-level knowledge of the Solaris, xBSD, Linux and Windows operating systems.  Familiarity with the file structures, processes, shell commands.  Basic system and administrative experience with UNIX required and with Windows operating systems preferred.
	</li><li>Understanding of TCP/IP networking, routing, operating systems relevant to system and network operation support from problem detection to recovery.
	</li><li>Experience writing shell scripts, and other scripting languages desired.
	<li>Basic understanding of CISCO based command and their usage a plus.
	</li><li>Strong organizational skills.  Must be capable of tracking/managing multiple issues simultaneously.  Strong verbal and written communication skills and the ability to convey complex issues in a concise manner is a must.
	</li><li>Prior supervisory experience is preferred, preferably in a NOC or a similar organization that?s engaged in technical support.
	</li><li>Three years recent experience in a technical support role is preferred, ideally with an ISP or with a communications provider.
	</li></ul>
	</blockquote>"
	)
  end

  def self.down
    drop_table :jobs
  end
end
